home *** CD-ROM | disk | FTP | other *** search
- Importing
-
-
-
- M.Y.O.B. version 3 can import data from another M.Y.O.B. data file or from any
-
- tab delimited or comma delimited file.
-
-
-
- You can import:
-
- Accounts
-
- Inventory Items
-
- Customer Cards
-
- Vendor Cards
-
- Employee Cards
-
- Personal Cards
-
- General Journal Entries *
-
- Other Sales **
-
- Other Purchases **
-
-
-
- * M.Y.O.B. imports all journal entries into the General Journal.
-
-
-
- ** M.Y.O.B. imports into Other Sales and Other Purchases. It does not
-
- import transactions into Invoice Sales or Purchase Orders.
-
-
-
- To import, select Import from the File menu, and select the desired data type
-
- from the Import sub-menu. The Import dialog appears.
-
-
-
- ÀáImport File FormatÀá
-
- Choose whether the file to be imported is in Tab Delimited or Comma Delimited
-
- format.
-
-
-
- ÀáFirst Record is...Àá
-
- Choose whether the first record of the file to be imported is a Header Record or a
-
- Data Record. A header record is a record containing the titles of the data fields.
-
- If you choose Header Record, M.Y.O.B. will not import the first record of the
-
- import file. It will use the header information to help you match the import
-
- data fields with the appropriate M.Y.O.B. data fields.
-
-
-
- ÀáAdditional Selection Criteria:Àá
-
-
-
- Accounts
-
- Duplicate Records
-
- The Chart of Accounts does not allow duplicate account numbers. If,
-
- while importing, M.Y.O.B. encounters a duplicate account number, it
-
- needs to know whether you want to reject the record or update the
-
- existing account information with the new account information from
-
- your import file.
-
-
-
- If you choose to reject duplicate accounts, the rejected records will be
-
- written to your M.Y.O.B. Import Log file (see Import Errors and
-
- Warnings).
-
-
-
- Inventory Items
-
- Duplicate Records
-
- The Items List does not allow duplicate item numbers. If, while
-
- importing, M.Y.O.B. encounters a duplicate item number, it needs to
-
- know whether you want to reject the record or update the existing item
-
- information with the new item information from your import file.
-
-
-
- If you choose to reject duplicate items, the rejected records will be
-
- written to your M.Y.O.B. Import Log file (see Import Errors and
-
- Warnings).
-
-
-
- Cards
-
- Duplicate Records
-
- The Card file does allow duplicate card names. If, while importing,
-
- M.Y.O.B. encounters a duplicate card name, it needs to know whether you
-
- want to reject the record, update the matching card with the new card
-
- information from your import file, or add the card to your card file.
-
-
-
- If you choose to reject duplicate cards, the rejected records will be
-
- written to your M.Y.O.B. Import Log file (see Import Errors and
-
- Warnings).
-
-
-
- Journal Entries
-
- None
-
- No additional selection criteria.
-
-
-
- Other Sales
-
- None
-
- No additional selection criteria.
-
-
-
- Other Purchases
-
- None
-
- No additional selection criteria.
-
-
-
-
-
- ÀáContinueÀá
-
- Click Continue after you've made your selections. Next M.Y.O.B. asks you to
-
- locate and open your import file.
-
-
-
- M.Y.O.B. reads the first record of the import file and displays the following
-
- screen, where you can match the fields from your import file to the fields in
-
- your M.Y.O.B. data file.
-
-
-
- First click an import field, then click the matching M.Y.O.B. field. The import
-
- field name will be written to the right of the M.Y.O.B. field name. To remove a
-
- field, click the M.Y.O.B. field name a second time. Fields with an asterisk to the
-
- left of their names are required by M.Y.O.B. You must match asterisk fields with
-
- a valid import field.
-
-
-
- ÀáMatch AllÀá
-
- Click Match All if your import data fields exactly match—line for line—
-
- M.Y.O.B.'s fields. This is true if your import file was created by M.Y.O.B.'s
-
- export routine.
-
-
-
- ÀáImportÀá
-
- Click Import after you've matched the fields. See Import Errors and Warnings
-
- for more details.
-
-